Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
PartyAffiliationTypeCode (FK)(PK) | A unique retailer assigned 2 leter code denoting the type of affiliation between two Partys. | CD_TYP_PRTY_AFLN | Code | varchar(20) | PartyAffiliationType(CO_TYP_PRTY_AFLN) |
PartyID (FK)(PK) | A unique, system assigned identity for a Party. | ID_PRTY | Identity | integer | Party(PA_PRTY) |
SubPartyID (FK)(PK) | A unique, system assigned identity for a Party. | ID_PRTY_AFLN | Identity | integer | Party(PA_PRTY) |
ChannelID (FK) | Token Identifier for a channel instance | ID_CHNL | Identity | integer | Channel(CO_CHNL) |
InvolvementTypeCode (FK) | Identifies and names a category of involvement. Examples: CREATORS - create content and originate ideas for the community CRITICS - review and comment on others' work COLLECTORS - Use material from others, add tag lines, comments JOINERS - Maintain profiles, visit SPECTATORS - Read material, read reviews, etc. INACTIVES - Joined community but not active This typically applies to PartyAffiliations between Person and Community. | CD_INVLVMNT_TYP | Code | varchar(20) | InvolvementType(LU_INVLVMNT) |
EffectiveDateTime | The date and time the affiliation between two parties was inforce | DT_AFLN_EF | EffectiveDateTime | datetime | |
ExpirationDateTime | The date and time the affiliation between two parties was no longer in force. | DT_AFLN_EP | ExpirationDateTime | datetime | |
StatusCode | Current status of the affiliation between two parties. Values include: ACTIVE INACTIVE Retailers may add other values if required, | SC_AFLN | Code2Status | char(2) | |
PrincipleSubPartyFlag | Boolean indicator that tells if the SubPartyID in this affiliation is a principle sub party or not. A principle subparty applies to affiliations like households and serves to identify the name and address of the "lead" member for contact purposes. A given household (or any non person group, community or houshold party type) may have one and only one designated PrincipleSubParty. Note that this rule has to be enforced in stored procedures or application code. It is not built into the data model. | FL_PRCNPL_SUB_PRTY | Flag | integer | |